package com.ocom.app.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ocom.common.entity.app.EntityTUser;
import com.ocom.common.vo.app.FindOrRegVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface IDaoTUser extends BaseMapper<EntityTUser> {


  @Select(
      "SELECT u.user_name AS userName,a.user_id AS userId,a.telele_phone AS telelePhone,a.type AS type \n"
          + "FROM t_user u INNER JOIN t_login_account a ON a.user_id = u.id  WHERE a.telele_phone = #{phoneNum}")
  FindOrRegVo findOrRegByPhoneNum(String phoneNum);
}
